想实现连接数据库,但老出错`

来源:百度知道 编辑:UC知道 时间:2024/06/30 05:10:47
想在程序中调出表web1中的所有数据``
数据源建好和表名一样也叫web1`
代码如下`
import java.sql.*;
public class searchuser
{
public Connection getcon()
{
String url="jdbc:odbc:web1";
String userN="";
String userC="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex)
{
System.out.print("the class isn't found");
}
try{
Connection con=DriverManager.getConnection(url,userN,userC);
}
catch(SQLException e)
{
System.out.print("the SQL isn't found");
}

return con;
}

public void getcontent(Connection con1,String sql1)
{
try
{
Statement st=con1.createStatement();
ResultSet rs=st.executeQuery(sql1);
while(rs.next())
{
String username=rs.getString("username");
String password=rs.getString("password");
String email=r

修改如下 删除和修改只要改一下 sql语句就可以了

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class searchuser {
public Connection getcon() {
Connection con = null;
String url = "jdbc:odbc:web1";
String userN = "";
String userC = "";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException ex) {
System.out.print("the class isn't found");
}
try {
con = DriverManager.getConnection(url, userN, userC);
} catch (SQLException e) {
System.out.print("the SQL isn't found");
}

return con;
}

public void getcontent(Connection con1, String sql1) {

try {
Statement st = con1.createStatement();
ResultSet rs = st.executeQuery(sql1);